Tabela CALEVENT

Definicja tabeli CALEVENT

Name

CALEVENT

Code

CALEVENT

Comment

 


Lista kolumn tabeli CALEVENT

Name

Code

CALEVENTID

CALEVENTID

CALCALENDARID

CALCALENDARID

ACTIVE

ACTIVE

ALLDAY

ALLDAY

STARTDT

STARTDT

STOPDT

STOPDT

SUMMARY

SUMMARY

DESCRIPTION

DESCRIPTION

LOCATION

LOCATION

CREATORID

CREATORID

INSERTINGPERSON

INSERTINGPERSON

INSERTDT

INSERTDT

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna CALEVENTID tabeli CALEVENT

Definicja kolumny CALEVENTID tabeli CALEVENT

Name

CALEVENTID

Code

CALEVENTID

Data Type

NUMBER(12,0)

Mandatory

Yes

Comment

 


Kolumna CALCALENDARID tabeli CALEVENT

Definicja kolumny CALCALENDARID tabeli CALEVENT

Name

CALCALENDARID

Code

CALCALENDARID

Data Type

NUMBER(12,0)

Mandatory

Yes

Comment

 


Kolumna ACTIVE tabeli CALEVENT

Definicja kolumny ACTIVE tabeli CALEVENT

Name

ACTIVE

Code

ACTIVE

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna ALLDAY tabeli CALEVENT

Definicja kolumny ALLDAY tabeli CALEVENT

Name

ALLDAY

Code

ALLDAY

Data Type

NUMBER(1,0)

Mandatory

No

Comment

 


Kolumna STARTDT tabeli CALEVENT

Definicja kolumny STARTDT tabeli CALEVENT

Name

STARTDT

Code

STARTDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna STOPDT tabeli CALEVENT

Definicja kolumny STOPDT tabeli CALEVENT

Name

STOPDT

Code

STOPDT

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SUMMARY tabeli CALEVENT

Definicja kolumny SUMMARY tabeli CALEVENT

Name

SUMMARY

Code

SUMMARY

Data Type

VARCHAR2(32)

Mandatory

Yes

Comment

 


Kolumna DESCRIPTION tabeli CALEVENT

Definicja kolumny DESCRIPTION tabeli CALEVENT

Name

DESCRIPTION

Code

DESCRIPTION

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna LOCATION tabeli CALEVENT

Definicja kolumny LOCATION tabeli CALEVENT

Name

LOCATION

Code

LOCATION

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna CREATORID tabeli CALEVENT

Definicja kolumny CREATORID tabeli CALEVENT

Name

CREATORID

Code

CREATORID

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna INSERTINGPERSON tabeli CALEVENT

Definicja kolumny INSERTINGPERSON tabeli CALEVENT

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna INSERTDT tabeli CALEVENT

Definicja kolumny INSERTDT tabeli CALEVENT

Name

INSERTDT

Code

INSERTDT

Data Type

DATE

Mandatory

Yes

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CALEVENT

Definicja kolumny LASTMODIFIEDPERSON tabeli CALEVENT

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

VARCHAR2(64)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CALEVENT

Definicja kolumny LASTMODIFIEDDT tabeli CALEVENT

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CALEVENT

Name

Code

Primary

PK_CALEVENT

PK_CALEVENT

X


Klucz PK_CALEVENT tabeli CALEVENT

Definicja klucza PK_CALEVENT tabeli CALEVENT

Name

PK_CALEVENT

Code

PK_CALEVENT

Primary

Yes

Comment